import appRoot from "app-root-path"
import { expect } from "chai"
import fs from "fs/promises"
import path from "path"
import { rimraf } from "rimraf"

import { DataSource } from "../../../../src/data-source/DataSource"
import { filepathToName } from "../../../../src/util/PathUtils"
import "../../../utils/test-setup"
import {
    closeTestingConnections,
    createTestingConnections,
    reloadTestingDatabases,
    withPlatform,
} from "../../../utils/test-utils"
import { Answer } from "./entity/Answer"
import { Category } from "./entity/Category"
import { Post } from "./entity/Post"
import { User } from "./entity/User"

const VALID_NAME_REGEX = /^(?!sqlite_).{1,63}$/

describe("multi-database > basic-functionality", () => {
    describe("filepathToName()", () => {
        for (const platform of [`darwin`, `win32`]) {
            it(`[${platform}] produces deterministic, unique, and valid table names for relative paths; leaves absolute paths unchanged`, () => {
                const testMap = [
                    ["FILENAME.db", "filename.db"],
                    [
                        "..\\FILENAME.db",
                        platform === "win32"
                            ? "../filename.db"
                            : "..\\filename.db",
                    ],
                    [
                        ".\\FILENAME.db",
                        platform === "win32"
                            ? "./filename.db"
                            : ".\\filename.db",
                    ],
                    [
                        "..\\longpathdir\\longpathdir\\longpathdir\\longpathdir\\longpathdir\\longpathdir\\longpathdir\\FILENAME.db",
                        platform === "win32"
                            ? "../longpathdir/longpathdir/longpathdir/longpathdir/longpathdir/longpathdir/longpathdir/filename.db"
                            : "..\\longpathdir\\longpathdir\\longpathdir\\longpathdir\\longpathdir\\longpathdir\\longpathdir\\filename.db",
                    ],
                    ["C:\\dirFILENAME.db", "C:\\dirFILENAME.db"],
                    ["/dir/filename.db", "/dir/filename.db"],
                ]
                for (const [winOs, otherOs] of testMap) {
                    const winOsRes = withPlatform(platform, () =>
                        filepathToName(winOs),
                    )
                    const otherOsRes = withPlatform(platform, () =>
                        filepathToName(otherOs),
                    )
                    expect(winOsRes).to.equal(otherOsRes)
                    expect(winOsRes).to.match(
                        VALID_NAME_REGEX,
                        `'${winOs}' is invalid table name`,
                    )
                }
            })
        }
    })

    describe("multiple databases", () => {
        let connections: DataSource[]
        const tempPath = path.resolve(appRoot.path, "temp")
        const attachAnswerPath = path.join(
            tempPath,
            "filename-sqlite.attach.db",
        )
        const attachAnswerHandle = filepathToName("filename-sqlite.attach.db")
        const attachCategoryPath = path.join(
            tempPath,
            "./subdir/relative-subdir-sqlite.attach.db",
        )
        const attachCategoryHandle = filepathToName(
            "./subdir/relative-subdir-sqlite.attach.db",
        )

        before(async () => {
            connections = await createTestingConnections({
                entities: [Answer, Category, Post, User],
                // enabledDrivers: ["sqlite", "better-sqlite3"],
                enabledDrivers: ["sqlite"],
            })
            connections = connections.filter(
                (connection) => connection.name === "sqlite",
            )
        })
        beforeEach(() => reloadTestingDatabases(connections))
        after(async () => {
            await closeTestingConnections(connections)
            await rimraf(`${tempPath}/**/*.attach.db`, { glob: true })
        })

        it("should correctly attach and create database files", () =>
            Promise.all(
                connections.map(async () => {
                    const expectedMainPath = path.join(
                        tempPath,
                        (connections[0].options.database as string).match(
                            /^.*[\\|/](?<filename>[^\\|/]+)$/,
                        )!.groups!["filename"],
                    )

                    await expect(fs.access(expectedMainPath, fs.constants.F_OK))
                        .to.not.be.rejected
                    await expect(fs.access(attachAnswerPath, fs.constants.F_OK))
                        .to.not.be.rejected
                    await expect(
                        fs.access(attachCategoryPath, fs.constants.F_OK),
                    ).to.not.be.rejected
                }),
            ))

        it("should prefix tableName when custom database used in Entity decorator", () =>
            Promise.all(
                connections.map(async (connection) => {
                    const queryRunner = connection.createQueryRunner()

                    const tablePathAnswer = `${attachAnswerHandle}.answer`
                    const table = await queryRunner.getTable(tablePathAnswer)
                    await queryRunner.release()

                    const answer = new Answer()
                    answer.text = "Answer #1"

                    await connection.getRepository(Answer).save(answer)

                    const sql = connection
                        .createQueryBuilder(Answer, "answer")
                        .where("answer.id = :id", { id: 1 })
                        .getSql()

                    sql.should.be.equal(
                        `SELECT "answer"."id" AS "answer_id", "answer"."text" AS "answer_text" FROM "${attachAnswerHandle}"."answer" "answer" WHERE "answer"."id" = 1`,
                    )
                    table!.name.should.be.equal(tablePathAnswer)
                }),
            ))

        it("should not affect tableName when using default main database", () =>
            Promise.all(
                connections.map(async (connection) => {
                    const queryRunner = connection.createQueryRunner()

                    const tablePathUser = `user`
                    const table = await queryRunner.getTable(tablePathUser)
                    await queryRunner.release()

                    const user = new User()
                    user.name = "User #1"
                    await connection.getRepository(User).save(user)

                    const sql = connection
                        .createQueryBuilder(User, "user")
                        .where("user.id = :id", { id: 1 })
                        .getSql()

                    sql.should.be.equal(
                        `SELECT "user"."id" AS "user_id", "user"."name" AS "user_name" FROM "user" "user" WHERE "user"."id" = 1`,
                    )

                    table!.name.should.be.equal(tablePathUser)
                }),
            ))

        it("should create foreign keys for relations within the same database", () =>
            Promise.all(
                connections.map(async (connection) => {
                    const queryRunner = connection.createQueryRunner()
                    const tablePathCategory = `${attachCategoryHandle}.category`
                    const tablePathPost = `${attachCategoryHandle}.post`
                    const tableCategory = (await queryRunner.getTable(
                        tablePathCategory,
                    ))!
                    const tablePost = (await queryRunner.getTable(
                        tablePathPost,
                    ))!
                    await queryRunner.release()

                    expect(tableCategory.foreignKeys.length).to.eq(1)
                    expect(
                        tableCategory.foreignKeys[0].columnNames.length,
                    ).to.eq(1) // before the fix this was 2, one for each schema
                    expect(tableCategory.foreignKeys[0].columnNames[0]).to.eq(
                        "postId",
                    )

                    expect(tablePost.foreignKeys.length).to.eq(0)
                }),
            ))
    })
})
